Data Source from SQL Server to Power BI 7

Step 1. Open your SQL Server

SQL Server Connection

Server: hypv8669.hostedbyappliedi.net

Username: ColaberryPowerBIReporting

pw: Colaberry99

Database Name:  ColaberryPowerBI_Reporting

Below is a screenshot of creating a server connection with Colaberry Server.


Once you have created the steps above you can then watch the GIF below in order to view your data inside of SQL Server once connected to Colaberry Server.



Step 2. Load data from SQL Server into Power BI Desktop

Step 1. Open Power BI Desktop and on the upper left ribbon, click on get data and choose SQL Server.

Step 2.  For the log in credentials of the data source use server name and database name provided below:

              Server: hypv8669.hostedbyappliedi.net

              Database: ColaberryPowerBI_Reporting  

Select import mode then click on OK.

1.


2.


Follow the GIF below.



Note: If you have any errors while you are connecting to  the SQL Server follow screenshots below .


Learn more about how to load data into power bi:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

Data Source from SQL Server to Power BI 7

Step 1. Open your SQL Server

SQL Server Connection

Server: hypv8669.hostedbyappliedi.net

Username: ColaberryPowerBIReporting

pw: Colaberry99

Database Name:  ColaberryPowerBI_Reporting

Below is a screenshot of creating a server connection with Colaberry Server.


Once you have created the steps above you can then watch the GIF below in order to view your data inside of SQL Server once connected to Colaberry Server.



Step 2. Load data from SQL Server into Power BI Desktop

Step 1. Open Power BI Desktop and on the upper left ribbon, click on get data and choose SQL Server.

Step 2.  For the log in credentials of the data source use server name and database name provided below:

              Server: hypv8669.hostedbyappliedi.net

              Database: ColaberryPowerBI_Reporting  

Select import mode then click on OK.

1.


2.


Follow the GIF below.



Note: If you have any errors while you are connecting to  the SQL Server follow screenshots below .


Learn more about how to load data into power bi:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial